package com.xo.xodemo.mapper.db1;

import com.xo.xodemo.model.ProofBargain;
import com.xo.xodemo.model.ProofBargainForStatistics;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

@Mapper
public interface ProofBargainMapper {
    int  insert(@Param("ProofBargain") ProofBargain proofBargain);
    ProofBargain   selectById(@Param("id") String id);
    int  updateById(@Param("ProofBargain") ProofBargain proofBargain);
    int  updateaddById(@Param("ProofBargain") ProofBargain proofBargain);

    int updateByImagePathAndId(@Param("id") String id, @Param("result") String result); //根据id修改图片数据


     List<ProofBargain> selectByauditerstatusandauditingperson(@Param("auditerstatus") String auditerstatus,@Param("userId") String userId);
    List<ProofBargain>  selectByapplyName(@Param("applyName") String applyName);
    List<ProofBargain>  selectHasDone();
    int auditingtrue(@Param("id") String id);
    int auditingfalse(@Param("id") String id);
    int Completed(@Param("id") String id, @Param("endTime")Date endTime,@Param("duration") Long duration);
    //查询所有数据的金额，日期，部门，给销售统计用
    List<ProofBargainForStatistics> selectPaymentAmount();
}
